lyfz_repos/铂金版源码/DBFile/SQL/2015-08-13[收集]/2015-09-30(腾工2).sql

--================添加记录-------------2015-09-30
--系统类别表--
Declare @ParentID int
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAD');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAQ') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAQ', '流程把控', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAR') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAR', '业务咨询', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAS') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAS', '满意度调查', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAT') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAT', '意向跟踪', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAU') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAU', '关系维护', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAV') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAV', '摄控安排', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------摄控安排
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAV');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAW') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAW', '选衣客人', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAY') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAAAY', '拍照客人', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABA') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABA', '看版客人', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABB') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABB', '取件客人', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABC') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABC', '服务客人', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------流程把控
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAQ');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABD') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABD', '已定未拍', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABF') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABF', '已拍未修', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABG') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABG', '已拍未选', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABH') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABH', '已修未选', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABI') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABI', '已选未设计', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABJ') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABJ', '已设计未看', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABK') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABK', '已看未发片', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABL') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABL', '已发未回件', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABM') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABM', '已回件未取', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------关系维护
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAU');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABN') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABN', '结婚纪念日祝福', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABO') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABO', '生日祝福', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end

-------------意向跟踪
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAT');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABP') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABP', '意向客户跟踪', @ParentID, 'False', 'True', '', 'True', 'False')
	end

	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABQ') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABQ', '溜单追回', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO
-------------满意度调查
set @ParentID = 0
set @ParentID = (select top 1 ID from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAAAS');
if @ParentID is not null and @ParentID > 0
begin
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABR') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABR', '回访接单', @ParentID, 'False', 'True', '', 'True', 'False')
	end
	if (select count(ID) from tb_ErpSystemCategory where Sc_ClassCode = 'AAAAABS') <= 0
	begin
		insert into tb_ErpSystemCategory(Sc_ClassCode, Sc_ClassName, Sc_ClassParentID, Sc_IsDisable, Sc_IsReadOnly, Sc_URL, Sc_IsDelete, Sc_IsEnabledURL) 
		values('AAAAABS', '回访拍摄', @ParentID, 'False', 'True', '', 'True', 'False')
	end
end
GO